Generating the task

After the data warehouse tables have been created, you then need to generate the task that will be used in the data warehouse task. The task contains the Mappings ETL (which is automatically created) and any custom ETLs that you have defined. If you need to make changes to the Mappings or define custom ETLs, continue from Managing tasks and Creating and managing custom ETLs respectively.

To generate the data warehouse task:

1. Click the Manage button in the bottom left of the Data Warehouse panel. The Manage Data Warehouse Tasks window opens.

2. If you have more than one task, in the left pane, select the task that you want to generate.

3. Do one of the following:

   • To generate the task with all validations, click the Generate toolbar button .
   • To generate the task with basic validations, click the inverted triangle to the right of the Generate button and select Basic validations from the drop-down menu.

   By default, Compose generates the task with all validations. However, when many expressions and lookups are defined, generating with all validations may take a long time. In such a case, you can try generating with basic validations instead. With basic validations, validations that may take a while (such as those that access databases to verify the existence of columns used in expressions and lookups), will be skipped.

    

   The Generating task for <Name> progress window opens. When the "Generate task finished successfully" message is displayed, close the window.

   Information note

   Only mappings selected in the Manage Data Warehouse Tasks window will be generated.